pg_hba.conf change in 7.4
От | Seum-Lim Gan |
---|---|
Тема | pg_hba.conf change in 7.4 |
Дата | |
Msg-id | p05100300bbe295614d7e@[135.185.171.70] обсуждение исходный текст |
Ответы |
Re: pg_hba.conf change in 7.4
|
Список | pgsql-general |
Hi, In 7.4, I noticed there is this ::1 and ffff: (x8 of them) for IPv6. I looked at the documentation and there is nothing that says what the ::1 is for. Commenting out that line will prevent access to PostgreSQL from psql unless I put trust for that line. This is what I had in 7.3.4: host all all 127.0.0.1 255.255.255.255 ident pspmap local all all password host all all 0.0.0.0 0.0.0.0 reject But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere. If I change the line with ::1 from trust to ident pspmap, it complains that the user cannot be found. But it is in the pspmap. Message fromm psql: psql: FATAL: IDENT authentication failed for user "postgres" Right now, I have it set to trust to work around. Any idea what to do about this ? host all all 127.0.0.1 255.255.255.255 ident pspmap local all all password host all all 0.0.0.0 0.0.0.0 reject # IPv4-style local connections: #host all all 127.0.0.1 255.255.255.255 trust # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust Thanks. Gan -- +--------------------------------------------------------+ | Seum-Lim GAN email : slgan@lucent.com | | Lucent Technologies | | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 | | Naperville, IL 60566, USA. fax : (630)-713-7272 | | web : http://inuweb.ih.lucent.com/~slgan | +--------------------------------------------------------+
В списке pgsql-general по дате отправления: